package com.ssm.server.boxes.dao;

import com.ssm.server.boxes.model.Boxes;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author zhangyibo
 */
@Repository
public interface BoxesDao {
	
    public List<Boxes> getBoxesByBoxesNumber(@Param("startNumber") int startNumber,
    											@Param("endNumber") int endNumber,
    											@Param("classesId") int classesId,
    											@Param("orderbyNumberDesc") int orderbyNumberDesc,
    	    									@Param("orderbyNowSumDesc") int orderbyNowSumDesc,
    	    									@Param("boxLevels") int boxLevels);

	public Boxes getBoxes(int boxesId);
	public Boxes getBoxesById(int boxesId);

	
    public int  countBoxes (int classesId);
    public List<Boxes> getBoxesByClassId(@Param("classesId") int classesId,
    									@Param("orderbyNumberAsc") int orderbyNumberAsc,
    									@Param("orderbyNowSumAsc") int orderbyNowSumAsc,
    									@Param("pageCount") int pageCount,
    									@Param("countSize") int countSize);
    public void updateBoxesState(Boxes boxes);

    
}
